package com.example.prison.service;

import com.example.prison.entity.VisitorAppointment;
import com.baomidou.mybatisplus.extension.service.IService;
import com.github.pagehelper.PageInfo;

import java.util.List;

/**
* @author jiang
* @description 针对表【visitor_appointment】的数据库操作Service
* @createDate 2024-06-03 09:12:46
*/
public interface VisitorAppointmentService extends IService<VisitorAppointment> {

    PageInfo<VisitorAppointment> get(int pageNumber, int pageSize,String visitorName,String beginTime,String endTime,String appointmentStatus,String visitorStatus,String visitDepartment);

    int add(VisitorAppointment vistor);

    void delete(Integer[] ids);

    int update(VisitorAppointment visitor, Integer id);

    VisitorAppointment getById(Integer id);

    String getCarNumberSum(String appointmentStatus);

    PageInfo<VisitorAppointment> getTodayVisitor(int pageNumber, int pageSize, String visitorName);

    String getTodayVisitorCarSum();

    PageInfo<VisitorAppointment> getTodayVisitorCar(String carLicense);

    VisitorAppointment getByIDCardNumber(String idCard);

    PageInfo<VisitorAppointment> getRetentionVisitor(int pageNumber, int pageSize, String visitorStatus, String appointmentTime, String visitorName, String beginTime, String endTime);

    PageInfo<VisitorAppointment> getByStatusAndTime(int pageNumber, int pageSize,String visitorStatus, String appointmentTime, String visitorName, String beginTime, String endTime);

    List<VisitorAppointment> getByNameAndTimeOrderTime(String visitorName, String appointmentTime);

    VisitorAppointment getByPIDAndTime(String pid, String appointmentTime);
}
